package com.lm.activiti.boot.tools.excel;

import cn.hutool.poi.excel.BigExcelWriter;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;

import java.io.File;
import java.io.IOException;

/**
 * @author lm_jcf
 * @date 2020/4/27 17:42
 */
public class ExcelReaderTest {


    @Test
    public void fileReader() {
    }

    @Test
    public void fileWriter(){
        BigExcelWriter writer = ExcelUtil.getBigWriter("");

//        writer.setDestFile()
    }

    @Test
    public void sxssWorkbook() throws IOException, InvalidFormatException {

        XSSFWorkbook xssfWorkbook = new XSSFWorkbook(new File("C:\\Users\\lm_jcf\\Desktop\\文件导出.xlsx"));
        SXSSFWorkbook workbook = new SXSSFWorkbook(xssfWorkbook, 100);



    }
}
